| Server IP : 121.121.20.254 / Your IP : 216.73.217.89 Web Server : Microsoft-IIS/10.0 System : Windows NT WEB-SERVER 10.0 build 20348 (Windows Server 2022) AMD64 User : IUSR ( 0) PHP Version : 8.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/LibreOffice/help/en-US/text/sbasic/shared/ |
Upload File : |
<!DOCTYPE html> <html lang="en-US" dir="ltr"> <head> <base href="../../../../"> <noscript><meta http-equiv="refresh" content="0; URL=../../../../en-US/noscript.html"></noscript> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Date and Time Functions</title> <link rel="shortcut icon" href="media/navigation/favicon.ico"> <link type="text/css" href="normalize.css" rel="Stylesheet"> <link type="text/css" href="prism.css" rel="Stylesheet"> <link type="text/css" href="default.css" rel="Stylesheet"> <script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="en-US/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1"> </head> <body> <header id="TopLeftHeader"><a class="symbol" href="en-US/text/shared/05/new_help.html"><div></div></a><a class="logo" href="en-US/text/shared/05/new_help.html"><p dir="auto">LibreOffice 24.2 Help</p></a><div class="dropdowns"><div class="modules"> <button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Module</button><nav id="modules-nav" hidden=""></nav> </div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contents</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks"> <input id="search-bar" type="search" class="search" placeholder="Search in bookmarks for chosen module" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div> </div></div> <div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication"> <a name="date_time"></a> <h1 id="hd_id3150502" dir="auto">Date and Time Functions</h1> <p id="par_id3153255" class="paragraph" dir="auto">Use the statements and functions described here to perform date and time calculations.</p> <p id="par_id3152363" class="paragraph" dir="auto"><span class="productname">LibreOffice</span> Basic lets you calculate time or date differences by converting the time and date values to continuous numeric values. After the difference is calculated, special functions are used to reconvert the values to the standard time or date formats.</p> <div class="tip"> <div class="noteicon" dir="auto"><img src="media/icon-themes/res/helpimg/tip.svg" alt="Tip Icon " style="width:40px;height:40px;"></div> <div class="notetext"><p dir="auto">You can combine date and time values into a single floating-decimal number. Dates are converted to integers, and times to decimal values. <span class="productname">LibreOffice</span> Basic also supports the variable type Date, which can contain a time specification consisting of both a date and time.</p></div> </div> <br> <div class="embedded"> <a name="datevalues"></a> <h2 id="hd_id3147573" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03030100.html">Converting Date Values</a></h2> <p id="par_id3154760" class="paragraph" dir="auto">The following functions convert date values to calculable numbers and back.</p> </div> <div class="embedded"> <a name="timevalues"></a> <h2 id="hd_id3147226" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03030200.html">Converting Time Values</a></h2> <p id="par_id3149415" class="paragraph" dir="auto">The following functions convert time values to calculable numbers.</p> </div> <div class="embedded"> <a name="determine"></a> <h2 id="hd_id3154923" dir="auto"><a target="_top" href="en-US/text/sbasic/shared/03030300.html">System Date and Time</a></h2> <p id="par_id3149457" class="paragraph" dir="auto">The following functions and statements set or return the system date and time.</p> </div> </div> <div id="DonationFrame"></div> <footer><div id="DEBUG" class="debug"> <h3 class="bug">Help content debug info:</h3> <p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/sbasic/shared/03030000.xhp" target="_blank">/text/sbasic/shared/03030000.xhp</a></p> <p dir="auto">Title is: Date and Time Functions</p> <p id="bm_module" dir="auto"></p> <p id="bm_system" dir="auto"></p> <p id="bm_HID" dir="auto"></p> </div></footer> </body> </html>